﻿use employees
go
------------------3----------------------------------------------------------------
DECLARE  @value INT
SET @value=3
SELECT 
Count(*) AS [AMOUNT]
FROM [dbo].[Empl]
WHERE [Empl].[DeptId]=@value

SELECT 
Count([Empl].[DeptId]) AS [AMOUNT]
FROM [dbo].[Empl]
GROUP BY [Empl].[DeptId]
HAVING [Empl].[DeptId]=@value
